{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["README"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,9,6,15],[3,1,3,2],[12,9,16,16]]}
[]
[null,"Minor Surgery DES Report (NHS London)",null,null,null,null,null,null,null,"NOTE:"]
[null,null,null,null,null,null,null,null,null,"This will only work if Vision is on DLM485 or above."]
[null,"Search Date Range",null,null,null,null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"START","END"]
[null,{"$f":"EOMONTH(TODAY(),-4)+1","v":"2016-12-01"},{"$f":"EOMONTH(TODAY(),-1)","v":"2017-02-28"},null,null,null,null,null,null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[]
[null,null,null,null,null,null,null,null,null,"Last updated: 02/03/2017 v1.1"]
[null,"Information",null,null,null,null,null,null,null,"Written by: Bradley Sieve"]
[null,"This will count all the minor surgery procedures carried out within the date range",null,null,null,null,null,null,null,"Email:  bradley.sieve@visionhealth.co.uk"]
[null,"It will also show claim errors due to missing data and advise on what is missing on each claim sheet"]
[null,"Claim errors work from left to right, so if there are 2 errors the first of these will be displayed",null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[null,"The minor surgery Read codes are displayed at the very top of each sheet"]
[null,"If the mouse pointer is hovered over a Read code the Read description is displayed"]
[null,"Each claim section is divided by background colours to help work out what section is missing data"]
[null,"Each section must have at least one YES in it for a successful claim"]
[]
[null,"It is assumed that all relevant Read codes for each claim type will be entered on the same date "]
[null,"If a minor surgery consent code is recorded with no other claim Read codes on the same date it will be automatically removed."]
[null,"Once errors are resolved within the patient record, please run this report again for verification"]